package com.bidevalution.controller.ureport;

import com.bidevalution.business.service.JdbcTemplateService;
import org.springframework.beans.factory.annotation.Autowired;
import java.util.List;
import java.util.Map;

/**
 * 评审项专家独立报表数据组装
 *
 * @author 查慧英
 * @date 2019-12-01 20:54
 */
public class EvaluationItemOutcomeDate {
    @Autowired(required = false)
    private JdbcTemplateService jdbcTemplateService;
    public List<Map<String,Object>> loadReportOutcomeData(String dsName, String datasetName, Map<String,Object> parameters){

        List<Map<String,Object>>  dataList = this.jdbcTemplateService.selectForList(
                "select enterprise_id,expert_id, c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20 " +
                        "from be_evalution_outcome where section_step_code=:stepCode and is_del='0' " +
                        "AND section_id=:sectionId AND expert_id=:expertId ",
                parameters);
        return ReportCommon.pushData(dataList);
    }
}
